﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		UPDATE eComWarehouseItems SET 
		<code><![CDATA[
			  if(true.Equals(info.get("updateAvailableQty")))
				sql.Append(@" availableQty = availableQty + @quantity ");
			  else
				sql.Append(@" onShelfQty = onShelfQty + @quantity ");
		]]></code>
		WHERE productId=@productId
	</Sql>
	<Param name="productId" type="UniqueIdentifier"/>
	<Param name="quantity" type="Integer"/>
</AdoNetDataAccess>
